TickerKeyDefinitionV3
One row per (TickerKey, tickerClass) - the join spine at the ticker rung. Holds only what is true of EVERY TickerKey; kind-specific facts live on satellites (RootDefinitionV3, CCodeDefinitionV3, BondIssueDefinitionV3, ObligorDefinitionV3 ...). TickerDefinition (4375) and TickerDefinitionExt (4380) are computed PROJECTIONS of this record. REGISTRY IDENTIFIERS ARE NOT HERE. isin, cusip, figi, lei and the Bloomberg codes ride ProductMappingV3 (9127); the 4375 projection reads them back out of it. WHICH KEYS GET A ROW is decided by pkey shape: TickerKey-pkeyed -> a row here, one per role the key plays ExpiryKey-pkeyed -> a deeper rung (Future, OptionExpiry) - no row OptionKey-pkeyed -> a leaf (Option, Bond, Pool, Tranche) - no row Futures ccodes and option roots are ticker-rung and DO get rows; the contracts and bonds beneath them do not.
METADATA
| Attribute | Value |
|---|---|
| Topic | 9100-product-def-core |
| MLink Token | EquityDefinition |
| Product | SRReference |
| accessType | SELECT |
| MLink Endpoint | MLink-Live |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| ticker_at | enum - AssetType | PRI | 'None' | asset type and ticker source are IN the key no separate fields |
| ticker_ts | enum - TickerSrc | PRI | 'None' | asset type and ticker source are IN the key no separate fields |
| ticker_tk | VARCHAR(12) | PRI | '' | asset type and ticker source are IN the key no separate fields |
| tickerClass | enum - TickerClass | PRI | 'None' | |
| symbolType | enum - SymbolType | 'None' | the sole navigation classifier read this one column no other casing | |
| cfi | VARCHAR(6) | '' | ISO 10962 the finer kind derives from it where symbolType stops | |
| cic | VARCHAR(4) | '' | Complementary Identification Code | |
| symbol | VARCHAR(12) | '' | trading symbol no dot notation | |
| name | VARCHAR(72) | '' | ||
| country | VARCHAR(2) | '' | ISO issuer country | |
| primaryCurrency | VARCHAR(3) | '' | ||
| parentTicker_at | enum - AssetType | 'None' | crosssource is fine it is just a key | |
| parentTicker_ts | enum - TickerSrc | 'None' | crosssource is fine it is just a key | |
| parentTicker_tk | VARCHAR(12) | '' | crosssource is fine it is just a key | |
| regionalCompositeTicker_at | enum - AssetType | 'None' | listingrung uplink a VenueListing rows line the key VenueListingDefinitionV3 9139 quoteKey names distinct from parentTicker | |
| regionalCompositeTicker_ts | enum - TickerSrc | 'None' | listingrung uplink a VenueListing rows line the key VenueListingDefinitionV3 9139 quoteKey names distinct from parentTicker | |
| regionalCompositeTicker_tk | VARCHAR(12) | '' | listingrung uplink a VenueListing rows line the key VenueListingDefinitionV3 9139 quoteKey names distinct from parentTicker | |
| displaySecKey_at | enum - AssetType | 'None' | ||
| displaySecKey_ts | enum - TickerSrc | 'None' | ||
| displaySecKey_tk | VARCHAR(12) | '' | ||
| displaySecKey_yr | SMALLINT UNSIGNED | 0 | ||
| displaySecKey_mn | TINYINT UNSIGNED | 0 | ||
| displaySecKey_dy | TINYINT UNSIGNED | 0 | ||
| displaySecKey_xx | DOUBLE | 0 | ||
| displaySecKey_cp | enum - CallPut | 'Call' | ||
| displaySecType | enum - SpdrKeyType | 'None' | ||
| displayMeaningNote | TINYTEXT | '' | what the designated quote is taken to represent | |
| displayRationaleNote | TINYTEXT | '' | why this one was chosen | |
| tkDefSource | enum - TkDefSource | 'None' | None Vendor OTC SR Exchange | |
| statusFlag | enum - TkStatusFlag | 'None' | None Active Delisted | |
| pendingDelete | enum - YesNo | 'None' | ||
| sourceNote | TINYTEXT | '' | ||
| v3Source | enum - V3Source | 'None' | ||
| timestamp | DATETIME(6) | '1900-01-01 00:00:00.000000' |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| ticker_tk | 1 |
| ticker_at | 2 |
| ticker_ts | 3 |
| tickerClass | 4 |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRReference`.`MsgTickerKeyDefinitionV3`
WHERE
/* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY','RATE','CRDT','GCR','SWAP','ENT','MBS','SET','LOAN') */
`ticker_at` = 'NONE'
AND
/* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','SCE','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFEC','ICEFEF','CEQT','TSX','TMX','CRCY','CMDY','DTI','SOVN','SR_US','SR_EU','SR_AP','SR_UK','USD','EUR','GBP','CHF','JPY','CAD','AUD','HKD','KRW','INR','SGD','TWD','CNY','CNH','BRL','MXN','ZAR','SEK','NOK','DKK','PLN','ILS','TRY','NZD','THB','MYR','IDR','PHP','CZK','HUF','SAR','AED','CLP','COP') */
`ticker_ts` = 'NONE'
AND
/* Replace with a VARCHAR(12) */
`ticker_tk` = 'Example_ticker_tk'
AND
/* Replace with a ENUM('None','Ticker','CCode','Root') */
`tickerClass` = 'NONE';
Doc Columns Query
SELECT * FROM SRReference.doccolumns WHERE TABLE_NAME='TickerKeyDefinitionV3' ORDER BY ordinal_position ASC;